/*
	Created: Jonathan Turner
		On : 10/18/2013
Description: Updates a document from ID.
	Updates:
*/

ALTER PROCEDURE daycare.UpdateDocument
  @DocumentId INT
, @DocumentName VARCHAR(100)
, @ExpirationDate VARCHAR(100) = NULL
, @DocumentTypeId INT
AS 
  UPDATE  daycare.Documents
  SET     DocumentName = @DocumentName
        , ExpirationDate = @ExpirationDate
        , DocumentTypeId = @DocumentTypeId
  WHERE   DocumentId = @DocumentId
  GO